DROP TABLE [dbo].[system_cron_group_data]
GO
CREATE TABLE [dbo].[system_cron_group_data] (
[GroupId] int NOT NULL ,
[GroupName] nvarchar(255) NOT NULL ,
[AddTime] datetime2(7) NOT NULL ,
[Adder] nvarchar(255) NOT NULL ,
[ModifyTime] datetime2(7) NOT NULL ,
[Modifer] nvarchar(255) NOT NULL 
)


GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'system_cron_group_data', 
'COLUMN', N'GroupId')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'任务分组主键ID'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'system_cron_group_data'
, @level2type = 'COLUMN', @level2name = N'GroupId'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'任务分组主键ID'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'system_cron_group_data'
, @level2type = 'COLUMN', @level2name = N'GroupId'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'system_cron_group_data', 
'COLUMN', N'GroupName')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'分组名称'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'system_cron_group_data'
, @level2type = 'COLUMN', @level2name = N'GroupName'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'分组名称'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'system_cron_group_data'
, @level2type = 'COLUMN', @level2name = N'GroupName'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'system_cron_group_data', 
'COLUMN', N'AddTime')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'新增时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'system_cron_group_data'
, @level2type = 'COLUMN', @level2name = N'AddTime'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'新增时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'system_cron_group_data'
, @level2type = 'COLUMN', @level2name = N'AddTime'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'system_cron_group_data', 
'COLUMN', N'Adder')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'新增人员'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'system_cron_group_data'
, @level2type = 'COLUMN', @level2name = N'Adder'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'新增人员'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'system_cron_group_data'
, @level2type = 'COLUMN', @level2name = N'Adder'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'system_cron_group_data', 
'COLUMN', N'ModifyTime')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'修改时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'system_cron_group_data'
, @level2type = 'COLUMN', @level2name = N'ModifyTime'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'修改时间'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'system_cron_group_data'
, @level2type = 'COLUMN', @level2name = N'ModifyTime'
GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description', 
'SCHEMA', N'dbo', 
'TABLE', N'system_cron_group_data', 
'COLUMN', N'Modifer')) > 0) 
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'修改人员'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'system_cron_group_data'
, @level2type = 'COLUMN', @level2name = N'Modifer'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'修改人员'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'system_cron_group_data'
, @level2type = 'COLUMN', @level2name = N'Modifer'
GO

-- ----------------------------
-- Indexes structure for table system_cron_group_data
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table system_cron_group_data
-- ----------------------------
ALTER TABLE [dbo].[system_cron_group_data] ADD PRIMARY KEY ([GroupId])
GO
